-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 30, 2008 at 03:21 PM
-- Server version: 3.23.52
-- PHP Version: 4.2.3
-- 
-- Database: `Computer Company`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `customers`
-- 

CREATE TABLE `customers` (
  `CID` int(9) NOT NULL default '0',
  `CName` varchar(60) NOT NULL default '',
  `CAge` int(99) NOT NULL default '0',
  `CTel` int(9) NOT NULL default '0',
  `CAddress` text NOT NULL,
  `CEmail` varchar(50) NOT NULL default '',
  `CCountry` varchar(60) NOT NULL default '',
  `CCity` varchar(15) NOT NULL default '',
  `CCreditCard` int(16) NOT NULL default '0',
  `UserName` int(99) NOT NULL default '0',
  `Password` varchar(15) NOT NULL default '0',
  PRIMARY KEY  (`CID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `customers`
-- 

INSERT INTO `customers` VALUES (1, 'Alya Ali AlKaabi', 20, 50, 'PO Box: 24322', '200607203@uaeu.ac.ae', 'UAE', 'Dubai', 2147483647, 200607203, '123456');
INSERT INTO `customers` VALUES (2, 'Abeer Ahmed', 21, 50, 'PO Box: 98375', '200613071@uaeu.ac.ae', 'UAE', 'Al-Fujaira', 2147483647, 200613071, '234567');
INSERT INTO `customers` VALUES (3, 'Aamena Al Shehyari', 19, 50, 'PO Box: 83629', '200613427@uaeu.ac.ae', 'UAE', 'RAK', 2147483647, 200613427, '345678');
INSERT INTO `customers` VALUES (4, 'Sarah Al Noaimy', 22, 50, 'PO Box:93759', '200613520@uaeu.ac.ae', 'UAE', 'Abu Dhabi', 2147483647, 200613520, '456789');
INSERT INTO `customers` VALUES (5, 'Reem Salim', 24, 50, 'PO Box:83693', '200476936@uaeu.ac.ae', 'UAE', 'Al Ain', 2147483647, 200476936, '456789');

-- --------------------------------------------------------

-- 
-- Table structure for table `menu_name`
-- 

CREATE TABLE `menu_name` (
  `ID` int(9) NOT NULL auto_increment,
  `PCategory` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `menu_name`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `product_customer`
-- 

CREATE TABLE `product_customer` (
  `CID` int(9) NOT NULL default '0',
  `PID` int(9) NOT NULL default '0',
  `buying data` text NOT NULL,
  PRIMARY KEY  (`PID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `product_customer`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
  `PID` int(9) NOT NULL auto_increment,
  `PName` varchar(15) NOT NULL default '',
  `PCategory` varchar(50) NOT NULL default '',
  `PColor` varchar(15) NOT NULL default '',
  `PPrice` varchar(11) NOT NULL default '0',
  `PQuantity` int(99) NOT NULL default '0',
  PRIMARY KEY  (`PID`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;

-- 
-- Dumping data for table `products`
-- 

INSERT INTO `products` VALUES (1, 'Toshiba Qosmio', 'Toshiba', 'Red', '$4,199.99', 50450);
INSERT INTO `products` VALUES (2, 'Lenovo IdeaPad', 'Lenovo', 'Black', '$1,199.00', 34562);
INSERT INTO `products` VALUES (3, 'Apple MacBook P', 'Apple', 'Black with silv', '$2,449.00', 67834);
INSERT INTO `products` VALUES (4, 'HP Mini 1000', 'HP', 'Black', '$399.99', 45654);
INSERT INTO `products` VALUES (5, 'HP TouchSmart I', 'HP', 'Black', '$223.794', 83450);
INSERT INTO `products` VALUES (6, 'iBuypower Gamer', 'Acer', 'Black', '$2,499', 73947);
INSERT INTO `products` VALUES (7, 'Dell Studio Des', 'Dell', 'Black', '$1,054.00', 49534);
INSERT INTO `products` VALUES (8, 'Acer Aspire X12', 'Acer', 'Black', '$1,054.00', 76354);
INSERT INTO `products` VALUES (9, 'Gateway FX6800', 'Gateway', 'Black', '$1,249', 87645);
INSERT INTO `products` VALUES (10, 'SanDisk Sansa C', 'MP3', 'Black with Blue', '$99', 87643);
INSERT INTO `products` VALUES (11, 'SanDisk Sansa S', 'MP3', 'Red', '$19.99', 2000);
INSERT INTO `products` VALUES (12, 'Apple iPod Nano', 'iPod', 'Blue', '$142.49', 23454);
INSERT INTO `products` VALUES (13, 'Altec Lansing T', 'MP4', 'Black', '$150.02', 64453);
INSERT INTO `products` VALUES (14, 'Apple iPod Touc', 'iPod', 'Silver', '$229.99', 563208);
INSERT INTO `products` VALUES (15, 'HP Photosmart C', 'HP', 'Silver', '$84.99', 78303);
INSERT INTO `products` VALUES (16, 'Canon Pixma MP6', 'Canon', 'Black with silv', '$149.99', 73945);
INSERT INTO `products` VALUES (17, 'Canon Pixma MX7', 'CanonPixma', 'Black with silv', '$399.99', 85303);
INSERT INTO `products` VALUES (18, 'Xerox Phaser 33', 'Xerox', 'white', '$618.15', 45352);
INSERT INTO `products` VALUES (19, 'Canon Selphy CP', 'Canon Selphy', 'White with oran', '$149.99', 83922);
INSERT INTO `products` VALUES (20, 'Intel X-25M SAT', 'HardDrive', 'black', '$595', 87635);
INSERT INTO `products` VALUES (21, 'Maxtor Black Ar', 'HardDrive', 'Black', '$149.99', 34874);
INSERT INTO `products` VALUES (22, 'Mtron Mobi 64GB', 'HardDrive', 'Silver', '$656.99', 75562);
INSERT INTO `products` VALUES (23, 'Transcend 64GB', 'HardDrive', 'Black', '$324', 34642);
INSERT INTO `products` VALUES (24, 'OCZ SATA II Sol', 'HardDrive', 'Silver', '$354.99', 46757);
INSERT INTO `products` VALUES (25, 'Trendnet 300Mbp', 'Networking', 'Black', '$55.99', 95832);
INSERT INTO `products` VALUES (26, 'D-Link RangeBoo', 'Networking', 'Black', '$90.58', 84540);
INSERT INTO `products` VALUES (27, 'ZyXel NSA220', 'Networking', 'white', '$214.49', 46232);
INSERT INTO `products` VALUES (28, 'Asus LS221H', 'Asus', 'Black', '$359.99', 126346);
INSERT INTO `products` VALUES (29, 'Westinghouse L1', 'Westinghouse', 'Black', '$179.99', 885352);
INSERT INTO `products` VALUES (30, 'Lenovo ThinkVis', 'Lenovo', 'Black', '$519.99', 628320);
INSERT INTO `products` VALUES (31, 'Gateway FHD2401', 'Gateway', 'Black', '$299', 0);
        